Labels:text | screenshot | display | number | parallel | font | line | software OCR: Server Statistics Options Predefined Configuration: None Close Parse Retrieval 1 . Defer Array Sizer 1 Describe Select List No. of Fetches: 1 Help Execution Long Data Combine Exection w/ Fetch Chunk Size: 2768 Bind Vars Minimize Sorting #Chunks to Retrieve: Rule Cost First Cost All Hints Data Statistica: Execute Only Rows Returned: Execute Only Parse & Execute Cates Parse Only Last Value Aug Value Time( Sec) Elapsed 0.00 0,00 Test Total CPU 0,00 0.00 1/0 blocks Physical Read 0 Logical Read 0 0 Beset Logical Write 0 Block size(bytes) 2048 Messaging Database calls 0 Advanced Recursive Calls No.of statements 0 0 Retrieval Sorts 0 Chained rows Summary 0 0 Full Table scans FIGURE 2 The Server Statistics dialog used for testing the execution of SQL statements for the different optimization modes.
